SELECT 
    JobTitle, 
    MAX(ph1.Rate) AS MaximumRate  
FROM 
    HumanResources.Employee AS e  
    JOIN HumanResources.EmployeePayHistory AS ph1 ON e.BusinessEntityID = ph1.BusinessEntityID  
GROUP BY 
    JobTitle  
HAVING 
    (
        MAX(CASE WHEN Gender = 'M' THEN ph1.Rate ELSE NULL END) > 40.00  
        OR 
        MAX(CASE WHEN Gender = 'F' THEN ph1.Rate ELSE NULL END) > 42.00
    )  
ORDER BY 
    MaximumRate DESC;

